package com.gxc.dao.impl;

import com.gxc.dao.UserDao;
import com.gxc.pojo.User;

/**
 * @Classname UserDaoImpl
 * @Description TODO
 * @Date 2020/11/16 8:02
 * @author by 97830
 */
public class UserDaoImpl extends BaseDao implements UserDao {
    @Override
    public User queryUserByUsername(String username) {
        String sql = "select id,username,password,email from t_user where username = ?";

        return  queryForOne(User.class, sql, username);
    }

    @Override
    public User queryUserByUsernameAndPassword(String username, String password) {
        String sql = "select id,username,password,email from t_user where username = ? and password = ?";
        return queryForOne(User.class, sql, username,password);
    }

    @Override
    public int addUser(User user) {
        String sql = "insert into t_user(username,password,email) values(?,?,?)";

        return update(sql, user.getUsername(),user.getPassword(),user.getEmail());
    }
}